<?php
  // sprites (because male/female sprites has different xml)
  require_once dirname(__FILE__)."/../purin2/alter/alter.php";

  // drop or clear
  puSql("drop table spri");
  puDelete("delete from spri");

  // create table
  puSql("create table spri (
    i_spri integer auto_increment not null, -- serial
    j_eqty integer not null,                -- join to equipment type
    v_race varchar(20) character set utf8 collate utf8_general_ci,                     -- race (male, female, null) - later will be counter probably
    v_xml varchar(50) character set utf8 collate utf8_general_ci not null,             -- sprite xml
    primary key (i_spri)
  )");

  // index
  puSql("create unique index p_spri_1 on spri (i_spri)");
  //puSql("create unique index s_eqty_1 on eqty (v_sprite)"); 
?>